Overview
Brought to you by YData
Dataset statistics
| Number of variables | 14 |
|---|---|
| Number of observations | 3150 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 165 |
| Duplicate rows (%) | 5.2% |
| Total size in memory | 344.7 KiB |
| Average record size in memory | 112.0 B |
Variable types
| Numeric | 8 |
|---|---|
| Categorical | 6 |
| Dataset has 165 (5.2%) duplicate rows | Duplicates |
Age is highly overall correlated with Age_Group | High correlation |
Age_Group is highly overall correlated with Age | High correlation |
Call_Failure is highly overall correlated with Charge_Amount and 2 other fields | High correlation |
Charge_Amount is highly overall correlated with Call_Failure | High correlation |
Churn is highly overall correlated with Complains | High correlation |
Complains is highly overall correlated with Churn | High correlation |
Customer_Value is highly overall correlated with Distinct_Called_Numbers and 3 other fields | High correlation |
Distinct_Called_Numbers is highly overall correlated with Call_Failure and 3 other fields | High correlation |
Frequency_of_SMS is highly overall correlated with Customer_Value | High correlation |
Frequency_of_use is highly overall correlated with Call_Failure and 4 other fields | High correlation |
Seconds_of_Use is highly overall correlated with Customer_Value and 3 other fields | High correlation |
Status is highly overall correlated with Frequency_of_use and 1 other fields | High correlation |
Complains is highly imbalanced (61.0%) | Imbalance |
Tariff_Plan is highly imbalanced (60.6%) | Imbalance |
Call_Failure has 702 (22.3%) zeros | Zeros |
Charge_Amount has 1768 (56.1%) zeros | Zeros |
Seconds_of_Use has 154 (4.9%) zeros | Zeros |
Frequency_of_use has 154 (4.9%) zeros | Zeros |
Frequency_of_SMS has 603 (19.1%) zeros | Zeros |
Distinct_Called_Numbers has 154 (4.9%) zeros | Zeros |
Customer_Value has 132 (4.2%) zeros | Zeros |
Reproduction
| Analysis started | 2025-03-16 13:45:46.112114 |
|---|---|
| Analysis finished | 2025-03-16 13:45:51.496279 |
| Duration | 5.38 seconds |
| Software version | ydata-profiling vv4.14.0 |
| Download configuration | config.json |
Variables
Call_Failure
Real number (ℝ)
High correlation Zeros
| Distinct | 37 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.6279365 |
| Minimum | 0 |
|---|---|
| Maximum | 36 |
| Zeros | 702 |
| Zeros (%) | 22.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 24.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 6 |
| Q3 | 12 |
| 95-th percentile | 22 |
| Maximum | 36 |
| Range | 36 |
| Interquartile range (IQR) | 11 |
Descriptive statistics
| Standard deviation | 7.2638856 |
|---|---|
| Coefficient of variation (CV) | 0.95227399 |
| Kurtosis | 0.90682067 |
| Mean | 7.6279365 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 1.0897518 |
| Sum | 24028 |
| Variance | 52.764034 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=37)
| Value | Count | Frequency (%) |
| 0 | 702 | |
| 5 | 244 | 7.7% |
| 7 | 166 | 5.3% |
| 6 | 161 | 5.1% |
| 8 | 156 | 5.0% |
| 9 | 149 | 4.7% |
| 3 | 141 | 4.5% |
| 2 | 137 | 4.3% |
| 4 | 133 | 4.2% |
| 11 | 125 | 4.0% |
| Other values (27) | 1036 |
| Value | Count | Frequency (%) |
| 0 | 702 | |
| 1 | 121 | 3.8% |
| 2 | 137 | 4.3% |
| 3 | 141 | 4.5% |
| 4 | 133 | 4.2% |
| 5 | 244 | 7.7% |
| 6 | 161 | 5.1% |
| 7 | 166 | 5.3% |
| 8 | 156 | 5.0% |
| 9 | 149 | 4.7% |
| Value | Count | Frequency (%) |
| 36 | 2 | 0.1% |
| 35 | 2 | 0.1% |
| 34 | 3 | 0.1% |
| 33 | 3 | 0.1% |
| 32 | 8 | |
| 31 | 6 | 0.2% |
| 30 | 16 | |
| 29 | 7 | |
| 28 | 17 | |
| 27 | 13 |
Complains
Categorical
High correlation Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 153.9 KiB |
| 0 | |
|---|---|
| 1 | 241 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 2909 | |
| 1 | 241 | 7.7% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 2909 | |
| 1 | 241 | 7.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 2909 | |
| 1 | 241 | 7.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3150 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 2909 | |
| 1 | 241 | 7.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3150 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 2909 | |
| 1 | 241 | 7.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3150 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 2909 | |
| 1 | 241 | 7.7% |
Subscription_Length
Real number (ℝ)
| Distinct | 45 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 32.541905 |
| Minimum | 3 |
|---|---|
| Maximum | 47 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 24.7 KiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 13 |
| Q1 | 30 |
| median | 35 |
| Q3 | 38 |
| 95-th percentile | 42 |
| Maximum | 47 |
| Range | 44 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 8.5734821 |
|---|---|
| Coefficient of variation (CV) | 0.26345975 |
| Kurtosis | 1.2158424 |
| Mean | 32.541905 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | -1.300015 |
| Sum | 102507 |
| Variance | 73.504595 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=45)
| Value | Count | Frequency (%) |
| 36 | 276 | 8.8% |
| 38 | 258 | 8.2% |
| 37 | 229 | 7.3% |
| 35 | 228 | 7.2% |
| 39 | 201 | 6.4% |
| 34 | 201 | 6.4% |
| 40 | 186 | 5.9% |
| 33 | 152 | 4.8% |
| 32 | 121 | 3.8% |
| 41 | 110 | 3.5% |
| Other values (35) | 1188 |
| Value | Count | Frequency (%) |
| 3 | 8 | 0.3% |
| 4 | 4 | 0.1% |
| 5 | 6 | 0.2% |
| 6 | 8 | 0.3% |
| 7 | 19 | |
| 8 | 12 | |
| 9 | 22 | |
| 10 | 16 | |
| 11 | 26 | |
| 12 | 19 |
| Value | Count | Frequency (%) |
| 47 | 1 | < 0.1% |
| 46 | 13 | 0.4% |
| 45 | 23 | 0.7% |
| 44 | 44 | 1.4% |
| 43 | 56 | 1.8% |
| 42 | 80 | 2.5% |
| 41 | 110 | |
| 40 | 186 | |
| 39 | 201 | |
| 38 | 258 |
Charge_Amount
Real number (ℝ)
High correlation Zeros
| Distinct | 11 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.94285714 |
| Minimum | 0 |
|---|---|
| Maximum | 10 |
| Zeros | 1768 |
| Zeros (%) | 56.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 24.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 4 |
| Maximum | 10 |
| Range | 10 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.5210719 |
|---|---|
| Coefficient of variation (CV) | 1.6132581 |
| Kurtosis | 8.8543583 |
| Mean | 0.94285714 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.5848682 |
| Sum | 2970 |
| Variance | 2.3136597 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=11)
| Value | Count | Frequency (%) |
| 0 | 1768 | |
| 1 | 617 | 19.6% |
| 2 | 395 | 12.5% |
| 3 | 199 | 6.3% |
| 4 | 76 | 2.4% |
| 5 | 30 | 1.0% |
| 8 | 19 | 0.6% |
| 9 | 14 | 0.4% |
| 7 | 14 | 0.4% |
| 6 | 11 | 0.3% |
| Value | Count | Frequency (%) |
| 0 | 1768 | |
| 1 | 617 | 19.6% |
| 2 | 395 | 12.5% |
| 3 | 199 | 6.3% |
| 4 | 76 | 2.4% |
| 5 | 30 | 1.0% |
| 6 | 11 | 0.3% |
| 7 | 14 | 0.4% |
| 8 | 19 | 0.6% |
| 9 | 14 | 0.4% |
| Value | Count | Frequency (%) |
| 10 | 7 | 0.2% |
| 9 | 14 | 0.4% |
| 8 | 19 | 0.6% |
| 7 | 14 | 0.4% |
| 6 | 11 | 0.3% |
| 5 | 30 | 1.0% |
| 4 | 76 | 2.4% |
| 3 | 199 | 6.3% |
| 2 | 395 | |
| 1 | 617 |
Seconds_of_Use
Real number (ℝ)
High correlation Zeros
| Distinct | 1756 |
|---|---|
| Distinct (%) | 55.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4472.4597 |
| Minimum | 0 |
|---|---|
| Maximum | 17090 |
| Zeros | 154 |
| Zeros (%) | 4.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 24.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 54.5 |
| Q1 | 1391.25 |
| median | 2990 |
| Q3 | 6478.25 |
| 95-th percentile | 15020.5 |
| Maximum | 17090 |
| Range | 17090 |
| Interquartile range (IQR) | 5087 |
Descriptive statistics
| Standard deviation | 4197.9087 |
|---|---|
| Coefficient of variation (CV) | 0.93861297 |
| Kurtosis | 0.99367573 |
| Mean | 4472.4597 |
| Median Absolute Deviation (MAD) | 1996 |
| Skewness | 1.3219429 |
| Sum | 14088248 |
| Variance | 17622437 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 154 | 4.9% |
| 305 | 37 | 1.2% |
| 710 | 9 | 0.3% |
| 2088 | 9 | 0.3% |
| 1015 | 9 | 0.3% |
| 1973 | 9 | 0.3% |
| 955 | 8 | 0.3% |
| 2393 | 8 | 0.3% |
| 1360 | 8 | 0.3% |
| 650 | 8 | 0.3% |
| Other values (1746) | 2891 |
| Value | Count | Frequency (%) |
| 0 | 154 | |
| 8 | 1 | < 0.1% |
| 13 | 1 | < 0.1% |
| 33 | 1 | < 0.1% |
| 50 | 1 | < 0.1% |
| 60 | 1 | < 0.1% |
| 73 | 1 | < 0.1% |
| 80 | 1 | < 0.1% |
| 88 | 1 | < 0.1% |
| 93 | 2 | 0.1% |
| Value | Count | Frequency (%) |
| 17090 | 1 | |
| 16980 | 1 | |
| 16785 | 1 | |
| 16675 | 1 | |
| 16640 | 1 | |
| 16570 | 1 | |
| 16560 | 1 | |
| 16500 | 1 | |
| 16495 | 1 | |
| 16480 | 1 |
Frequency_of_use
Real number (ℝ)
High correlation Zeros
| Distinct | 242 |
|---|---|
| Distinct (%) | 7.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 69.460635 |
| Minimum | 0 |
|---|---|
| Maximum | 255 |
| Zeros | 154 |
| Zeros (%) | 4.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 24.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 27 |
| median | 54 |
| Q3 | 95 |
| 95-th percentile | 184.55 |
| Maximum | 255 |
| Range | 255 |
| Interquartile range (IQR) | 68 |
Descriptive statistics
| Standard deviation | 57.413308 |
|---|---|
| Coefficient of variation (CV) | 0.82655893 |
| Kurtosis | 0.82012484 |
| Mean | 69.460635 |
| Median Absolute Deviation (MAD) | 33 |
| Skewness | 1.1441664 |
| Sum | 218801 |
| Variance | 3296.2879 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 154 | 4.9% |
| 6 | 49 | 1.6% |
| 44 | 38 | 1.2% |
| 39 | 37 | 1.2% |
| 41 | 35 | 1.1% |
| 36 | 33 | 1.0% |
| 33 | 33 | 1.0% |
| 19 | 32 | 1.0% |
| 45 | 32 | 1.0% |
| 47 | 32 | 1.0% |
| Other values (232) | 2675 |
| Value | Count | Frequency (%) |
| 0 | 154 | |
| 1 | 9 | 0.3% |
| 2 | 15 | 0.5% |
| 3 | 4 | 0.1% |
| 4 | 23 | 0.7% |
| 5 | 15 | 0.5% |
| 6 | 49 | 1.6% |
| 7 | 19 | 0.6% |
| 8 | 25 | 0.8% |
| 9 | 16 | 0.5% |
| Value | Count | Frequency (%) |
| 255 | 1 | < 0.1% |
| 254 | 2 | 0.1% |
| 252 | 1 | < 0.1% |
| 250 | 2 | 0.1% |
| 249 | 1 | < 0.1% |
| 248 | 2 | 0.1% |
| 247 | 1 | < 0.1% |
| 246 | 2 | 0.1% |
| 245 | 1 | < 0.1% |
| 244 | 5 |
Frequency_of_SMS
Real number (ℝ)
High correlation Zeros
| Distinct | 405 |
|---|---|
| Distinct (%) | 12.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 73.174921 |
| Minimum | 0 |
|---|---|
| Maximum | 522 |
| Zeros | 603 |
| Zeros (%) | 19.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 24.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 6 |
| median | 21 |
| Q3 | 87 |
| 95-th percentile | 356.55 |
| Maximum | 522 |
| Range | 522 |
| Interquartile range (IQR) | 81 |
Descriptive statistics
| Standard deviation | 112.23756 |
|---|---|
| Coefficient of variation (CV) | 1.5338255 |
| Kurtosis | 3.2585401 |
| Mean | 73.174921 |
| Median Absolute Deviation (MAD) | 21 |
| Skewness | 1.9741418 |
| Sum | 230501 |
| Variance | 12597.27 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 603 | 19.1% |
| 7 | 194 | 6.2% |
| 9 | 54 | 1.7% |
| 8 | 54 | 1.7% |
| 15 | 54 | 1.7% |
| 16 | 51 | 1.6% |
| 17 | 47 | 1.5% |
| 10 | 44 | 1.4% |
| 12 | 42 | 1.3% |
| 1 | 41 | 1.3% |
| Other values (395) | 1966 |
| Value | Count | Frequency (%) |
| 0 | 603 | |
| 1 | 41 | 1.3% |
| 2 | 39 | 1.2% |
| 3 | 32 | 1.0% |
| 4 | 30 | 1.0% |
| 5 | 29 | 0.9% |
| 6 | 26 | 0.8% |
| 7 | 194 | 6.2% |
| 8 | 54 | 1.7% |
| 9 | 54 | 1.7% |
| Value | Count | Frequency (%) |
| 522 | 1 | < 0.1% |
| 515 | 1 | < 0.1% |
| 511 | 1 | < 0.1% |
| 508 | 1 | < 0.1% |
| 505 | 1 | < 0.1% |
| 504 | 1 | < 0.1% |
| 501 | 1 | < 0.1% |
| 500 | 1 | < 0.1% |
| 499 | 1 | < 0.1% |
| 498 | 3 |
Distinct_Called_Numbers
Real number (ℝ)
High correlation Zeros
| Distinct | 92 |
|---|---|
| Distinct (%) | 2.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.509841 |
| Minimum | 0 |
|---|---|
| Maximum | 97 |
| Zeros | 154 |
| Zeros (%) | 4.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 24.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 10 |
| median | 21 |
| Q3 | 34 |
| 95-th percentile | 51 |
| Maximum | 97 |
| Range | 97 |
| Interquartile range (IQR) | 24 |
Descriptive statistics
| Standard deviation | 17.217337 |
|---|---|
| Coefficient of variation (CV) | 0.73234597 |
| Kurtosis | 1.3599904 |
| Mean | 23.509841 |
| Median Absolute Deviation (MAD) | 11 |
| Skewness | 1.0294021 |
| Sum | 74056 |
| Variance | 296.43671 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 154 | 4.9% |
| 2 | 88 | 2.8% |
| 10 | 78 | 2.5% |
| 15 | 77 | 2.4% |
| 17 | 76 | 2.4% |
| 6 | 76 | 2.4% |
| 8 | 75 | 2.4% |
| 20 | 75 | 2.4% |
| 19 | 75 | 2.4% |
| 16 | 74 | 2.3% |
| Other values (82) | 2302 |
| Value | Count | Frequency (%) |
| 0 | 154 | |
| 1 | 31 | 1.0% |
| 2 | 88 | |
| 3 | 44 | 1.4% |
| 4 | 63 | |
| 5 | 60 | 1.9% |
| 6 | 76 | |
| 7 | 61 | 1.9% |
| 8 | 75 | |
| 9 | 73 |
| Value | Count | Frequency (%) |
| 97 | 1 | < 0.1% |
| 95 | 1 | < 0.1% |
| 93 | 1 | < 0.1% |
| 88 | 1 | < 0.1% |
| 87 | 1 | < 0.1% |
| 86 | 3 | 0.1% |
| 85 | 3 | 0.1% |
| 84 | 4 | |
| 83 | 4 | |
| 82 | 8 |
Age_Group
Categorical
High correlation
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 153.9 KiB |
| 3 | |
|---|---|
| 2 | |
| 4 | |
| 5 | |
| 1 | 123 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 3 |
|---|---|
| 2nd row | 2 |
| 3rd row | 3 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 3 | 1425 | |
| 2 | 1037 | |
| 4 | 395 | 12.5% |
| 5 | 170 | 5.4% |
| 1 | 123 | 3.9% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 3 | 1425 | |
| 2 | 1037 | |
| 4 | 395 | 12.5% |
| 5 | 170 | 5.4% |
| 1 | 123 | 3.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| 3 | 1425 | |
| 2 | 1037 | |
| 4 | 395 | 12.5% |
| 5 | 170 | 5.4% |
| 1 | 123 | 3.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3150 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 3 | 1425 | |
| 2 | 1037 | |
| 4 | 395 | 12.5% |
| 5 | 170 | 5.4% |
| 1 | 123 | 3.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3150 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 3 | 1425 | |
| 2 | 1037 | |
| 4 | 395 | 12.5% |
| 5 | 170 | 5.4% |
| 1 | 123 | 3.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3150 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 3 | 1425 | |
| 2 | 1037 | |
| 4 | 395 | 12.5% |
| 5 | 170 | 5.4% |
| 1 | 123 | 3.9% |
Tariff_Plan
Categorical
Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 153.9 KiB |
| 1 | |
|---|---|
| 2 | 245 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 2905 | |
| 2 | 245 | 7.8% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 2905 | |
| 2 | 245 | 7.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 2905 | |
| 2 | 245 | 7.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3150 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 2905 | |
| 2 | 245 | 7.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3150 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 2905 | |
| 2 | 245 | 7.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3150 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 2905 | |
| 2 | 245 | 7.8% |
Status
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 153.9 KiB |
| 1 | |
|---|---|
| 2 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 2 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 2368 | |
| 2 | 782 | 24.8% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 2368 | |
| 2 | 782 | 24.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 2368 | |
| 2 | 782 | 24.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3150 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 2368 | |
| 2 | 782 | 24.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3150 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 2368 | |
| 2 | 782 | 24.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3150 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 2368 | |
| 2 | 782 | 24.8% |
Age
Categorical
High correlation
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 157.0 KiB |
| 30 | |
|---|---|
| 25 | |
| 45 | |
| 55 | |
| 15 | 123 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 30 |
|---|---|
| 2nd row | 25 |
| 3rd row | 30 |
| 4th row | 15 |
| 5th row | 15 |
Common Values
| Value | Count | Frequency (%) |
| 30 | 1425 | |
| 25 | 1037 | |
| 45 | 395 | 12.5% |
| 55 | 170 | 5.4% |
| 15 | 123 | 3.9% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 30 | 1425 | |
| 25 | 1037 | |
| 45 | 395 | 12.5% |
| 55 | 170 | 5.4% |
| 15 | 123 | 3.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| 5 | 1895 | |
| 3 | 1425 | |
| 0 | 1425 | |
| 2 | 1037 | |
| 4 | 395 | 6.3% |
| 1 | 123 | 2.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 6300 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 5 | 1895 | |
| 3 | 1425 | |
| 0 | 1425 | |
| 2 | 1037 | |
| 4 | 395 | 6.3% |
| 1 | 123 | 2.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 6300 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 5 | 1895 | |
| 3 | 1425 | |
| 0 | 1425 | |
| 2 | 1037 | |
| 4 | 395 | 6.3% |
| 1 | 123 | 2.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 6300 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 5 | 1895 | |
| 3 | 1425 | |
| 0 | 1425 | |
| 2 | 1037 | |
| 4 | 395 | 6.3% |
| 1 | 123 | 2.0% |
Customer_Value
Real number (ℝ)
High correlation Zeros
| Distinct | 2654 |
|---|---|
| Distinct (%) | 84.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 470.97292 |
| Minimum | 0 |
|---|---|
| Maximum | 2165.28 |
| Zeros | 132 |
| Zeros (%) | 4.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 24.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 10.335 |
| Q1 | 113.80125 |
| median | 228.48 |
| Q3 | 788.38875 |
| 95-th percentile | 1587.68 |
| Maximum | 2165.28 |
| Range | 2165.28 |
| Interquartile range (IQR) | 674.5875 |
Descriptive statistics
| Standard deviation | 517.01543 |
|---|---|
| Coefficient of variation (CV) | 1.0977604 |
| Kurtosis | 1.2244965 |
| Mean | 470.97292 |
| Median Absolute Deviation (MAD) | 160.5825 |
| Skewness | 1.4272916 |
| Sum | 1483564.7 |
| Variance | 267304.96 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 132 | 4.2% |
| 45.495 | 11 | 0.3% |
| 40.44 | 10 | 0.3% |
| 15.165 | 6 | 0.2% |
| 25.275 | 5 | 0.2% |
| 180 | 4 | 0.1% |
| 131.4 | 4 | 0.1% |
| 121.4 | 4 | 0.1% |
| 1538.145 | 4 | 0.1% |
| 191.92 | 3 | 0.1% |
| Other values (2644) | 2967 |
| Value | Count | Frequency (%) |
| 0 | 132 | |
| 2.34 | 1 | < 0.1% |
| 4 | 1 | < 0.1% |
| 4.41 | 1 | < 0.1% |
| 4.5 | 2 | 0.1% |
| 5.13 | 1 | < 0.1% |
| 5.175 | 1 | < 0.1% |
| 5.4 | 3 | 0.1% |
| 5.625 | 1 | < 0.1% |
| 5.94 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 2165.28 | 1 | |
| 2149.28 | 1 | |
| 2148.84 | 1 | |
| 2148.03 | 1 | |
| 2140.96 | 1 | |
| 2129.535 | 1 | |
| 2127.68 | 1 | |
| 2124.84 | 1 | |
| 2120.67 | 1 | |
| 2117.72 | 1 |
Churn
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 153.9 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 2655 | |
| 1 | 495 | 15.7% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 2655 | |
| 1 | 495 | 15.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 2655 | |
| 1 | 495 | 15.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3150 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 2655 | |
| 1 | 495 | 15.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3150 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 2655 | |
| 1 | 495 | 15.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3150 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 2655 | |
| 1 | 495 | 15.7% |
Interactions
Correlations
| Age | Age_Group | Call_Failure | Charge_Amount | Churn | Complains | Customer_Value | Distinct_Called_Numbers | Frequency_of_SMS | Frequency_of_use | Seconds_of_Use | Status | Subscription_Length | Tariff_Plan | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Age | 1.000 | 1.000 | 0.103 | 0.236 | 0.132 | 0.069 | 0.214 | 0.241 | 0.173 | 0.235 | 0.297 | 0.197 | 0.162 | 0.192 |
| Age_Group | 1.000 | 1.000 | 0.103 | 0.236 | 0.132 | 0.069 | 0.214 | 0.241 | 0.173 | 0.235 | 0.297 | 0.197 | 0.162 | 0.192 |
| Call_Failure | 0.103 | 0.103 | 1.000 | 0.572 | 0.035 | 0.170 | 0.346 | 0.514 | 0.270 | 0.550 | 0.466 | 0.121 | 0.249 | 0.224 |
| Charge_Amount | 0.236 | 0.236 | 0.572 | 1.000 | 0.176 | 0.063 | 0.393 | 0.437 | 0.319 | 0.447 | 0.490 | 0.321 | 0.150 | 0.367 |
| Churn | 0.132 | 0.132 | 0.035 | 0.176 | 1.000 | 0.530 | 0.318 | 0.296 | 0.253 | 0.338 | 0.353 | 0.498 | 0.217 | 0.103 |
| Complains | 0.069 | 0.069 | 0.170 | 0.063 | 0.530 | 1.000 | 0.143 | 0.078 | 0.125 | 0.143 | 0.158 | 0.269 | 0.137 | 0.000 |
| Customer_Value | 0.214 | 0.214 | 0.346 | 0.393 | 0.318 | 0.143 | 1.000 | 0.563 | 0.780 | 0.673 | 0.714 | 0.498 | 0.145 | 0.434 |
| Distinct_Called_Numbers | 0.241 | 0.241 | 0.514 | 0.437 | 0.296 | 0.078 | 0.563 | 1.000 | 0.321 | 0.824 | 0.763 | 0.447 | 0.157 | 0.219 |
| Frequency_of_SMS | 0.173 | 0.173 | 0.270 | 0.319 | 0.253 | 0.125 | 0.780 | 0.321 | 1.000 | 0.306 | 0.308 | 0.344 | 0.104 | 0.452 |
| Frequency_of_use | 0.235 | 0.235 | 0.550 | 0.447 | 0.338 | 0.143 | 0.673 | 0.824 | 0.306 | 1.000 | 0.937 | 0.536 | 0.174 | 0.422 |
| Seconds_of_Use | 0.297 | 0.297 | 0.466 | 0.490 | 0.353 | 0.158 | 0.714 | 0.763 | 0.308 | 0.937 | 1.000 | 0.596 | 0.145 | 0.312 |
| Status | 0.197 | 0.197 | 0.121 | 0.321 | 0.498 | 0.269 | 0.498 | 0.447 | 0.344 | 0.536 | 0.596 | 1.000 | 0.193 | 0.162 |
| Subscription_Length | 0.162 | 0.162 | 0.249 | 0.150 | 0.217 | 0.137 | 0.145 | 0.157 | 0.104 | 0.174 | 0.145 | 0.193 | 1.000 | 0.230 |
| Tariff_Plan | 0.192 | 0.192 | 0.224 | 0.367 | 0.103 | 0.000 | 0.434 | 0.219 | 0.452 | 0.422 | 0.312 | 0.162 | 0.230 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
Sample
| Call_Failure | Complains | Subscription_Length | Charge_Amount | Seconds_of_Use | Frequency_of_use | Frequency_of_SMS | Distinct_Called_Numbers | Age_Group | Tariff_Plan | Status | Age | Customer_Value | Churn | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 8 | 0 | 38 | 0 | 4370 | 71 | 5 | 17 | 3 | 1 | 1 | 30 | 197.640 | 0 |
| 1 | 0 | 0 | 39 | 0 | 318 | 5 | 7 | 4 | 2 | 1 | 2 | 25 | 46.035 | 0 |
| 2 | 10 | 0 | 37 | 0 | 2453 | 60 | 359 | 24 | 3 | 1 | 1 | 30 | 1536.520 | 0 |
| 3 | 10 | 0 | 38 | 0 | 4198 | 66 | 1 | 35 | 1 | 1 | 1 | 15 | 240.020 | 0 |
| 4 | 3 | 0 | 38 | 0 | 2393 | 58 | 2 | 33 | 1 | 1 | 1 | 15 | 145.805 | 0 |
| 5 | 11 | 0 | 38 | 1 | 3775 | 82 | 32 | 28 | 3 | 1 | 1 | 30 | 282.280 | 0 |
| 6 | 4 | 0 | 38 | 0 | 2360 | 39 | 285 | 18 | 3 | 1 | 1 | 30 | 1235.960 | 0 |
| 7 | 13 | 0 | 37 | 2 | 9115 | 121 | 144 | 43 | 3 | 1 | 1 | 30 | 945.440 | 0 |
| 8 | 7 | 0 | 38 | 0 | 13773 | 169 | 0 | 44 | 3 | 1 | 1 | 30 | 557.680 | 0 |
| 9 | 7 | 0 | 38 | 1 | 4515 | 83 | 2 | 25 | 3 | 1 | 1 | 30 | 191.920 | 0 |
| Call_Failure | Complains | Subscription_Length | Charge_Amount | Seconds_of_Use | Frequency_of_use | Frequency_of_SMS | Distinct_Called_Numbers | Age_Group | Tariff_Plan | Status | Age | Customer_Value | Churn | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3140 | 16 | 0 | 29 | 0 | 1005 | 31 | 17 | 9 | 3 | 1 | 2 | 30 | 109.44 | 0 |
| 3141 | 5 | 0 | 28 | 0 | 1130 | 16 | 28 | 5 | 4 | 1 | 2 | 45 | 98.65 | 0 |
| 3142 | 15 | 0 | 27 | 1 | 1530 | 38 | 26 | 15 | 2 | 1 | 1 | 25 | 187.56 | 0 |
| 3143 | 7 | 0 | 27 | 1 | 3530 | 67 | 15 | 25 | 3 | 1 | 1 | 30 | 203.88 | 0 |
| 3144 | 7 | 0 | 20 | 1 | 2000 | 32 | 35 | 16 | 3 | 1 | 1 | 30 | 221.28 | 0 |
| 3145 | 21 | 0 | 19 | 2 | 6697 | 147 | 92 | 44 | 2 | 2 | 1 | 25 | 721.98 | 0 |
| 3146 | 17 | 0 | 17 | 1 | 9237 | 177 | 80 | 42 | 5 | 1 | 1 | 55 | 261.21 | 0 |
| 3147 | 13 | 0 | 18 | 4 | 3157 | 51 | 38 | 21 | 3 | 1 | 1 | 30 | 280.32 | 0 |
| 3148 | 7 | 0 | 11 | 2 | 4695 | 46 | 222 | 12 | 3 | 1 | 1 | 30 | 1077.64 | 0 |
| 3149 | 8 | 1 | 11 | 2 | 1792 | 25 | 7 | 9 | 3 | 1 | 1 | 30 | 100.68 | 1 |
Duplicate rows
Most frequently occurring
| Call_Failure | Complains | Subscription_Length | Charge_Amount | Seconds_of_Use | Frequency_of_use | Frequency_of_SMS | Distinct_Called_Numbers | Age_Group | Tariff_Plan | Status | Age | Customer_Value | Churn | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29 | 0 | 0 | 35 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 2 | 25 | 0.000 | 1 | 6 |
| 42 | 0 | 0 | 37 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 2 | 25 | 0.000 | 0 | 6 |
| 24 | 0 | 0 | 34 | 0 | 0 | 0 | 0 | 0 | 5 | 1 | 1 | 55 | 0.000 | 0 | 5 |
| 43 | 0 | 0 | 37 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 2 | 25 | 0.000 | 1 | 5 |
| 22 | 0 | 0 | 34 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 2 | 25 | 0.000 | 1 | 4 |
| 28 | 0 | 0 | 35 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 2 | 25 | 0.000 | 0 | 4 |
| 33 | 0 | 0 | 36 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 2 | 25 | 0.000 | 0 | 4 |
| 85 | 5 | 0 | 39 | 0 | 305 | 6 | 7 | 2 | 2 | 1 | 2 | 25 | 45.495 | 1 | 4 |
| 1 | 0 | 0 | 7 | 0 | 4085 | 34 | 208 | 8 | 3 | 1 | 1 | 30 | 996.760 | 0 | 3 |
| 2 | 0 | 0 | 16 | 0 | 1390 | 20 | 21 | 12 | 2 | 1 | 1 | 25 | 157.950 | 0 | 3 |